[Mapping]
You have one [Mapping]
section for all of the nodes in your database cluster. The section must appear in your configuration file because it specifies alsl database nodes being included in the backup. It also includes the backup host and directory for each node. If you have objects being replicated to an alternate database, the[Mapping]
section also maps the target database nodes to the source database backup locations.
- If you edit an existing configuration file to add a Mapping in the current style, you must combine information from all existing Mappings into the new section.
- Alternatively, you can use
vbr
with the--setupconfig
option to generate a new configuration file, as described in Creating vbr Configuration Files.
Note: The [S3] and [Mapping] configuration sections are mutually exclusive. If you include both, your backup fails with the error message "Config has conflicting sections (Mapping, S3), specify only one of them.
"
Parameter | Default | Description |
---|---|---|
|
None |
Indicates the target host name or IP address on which to store this node's backup. The Performance Consideration: Although supported, backups to an NFS host may have poor performance, particularly on networks shared with rsync operations. |
|
None |
Identifies the full path to the directory on the backup host or node where the backup will be stored. Directory Requirements:
|
|
None |
The name of the database node, as recognized by Vertica. This value is not the node's host name, but rather the name Vertica uses internally to identify the node, usually in the form of: v_node00xx To find database node names in your cluster, query the |
Map to the localhost
Vertica vbr does not support the special localhost name as a backup host. To backup a database node to its own disk, use empty square brackets for the hostname in the [Mapping] section of the configuration file.
[Mapping]
NodeName = []:/backup/path
Your mapping section should resemble this example:
[Mapping]
v_node0001 = []:/scratch_drive/archive/backupdir
v_node0002 = []:/scratch_drive/archive/backupdir
v_node0003 = []:/scratch_drive/archive/backupdir
Map to the Same Database
The following example shows how you can specify a Mapping
section that indicates a single node to be backed up (v_vmart_node0001
). The node is assigned to the backup host (v_srv01
), and the backup directory (/home/dbadmin/backups
). Although you are backing up a single node cluster, and the backup host and the database node are the same system, you specify them differently.
Specify the backup host and directory, using a colon (:
) as a separator:
[Mapping]
v_vmart_node0001 = srv01:/home/dbadmin/backups
Although the configuration file [Mapping]
section no longer uses named parameters, you still use the elements of the simplified format continue to represent the following parameters:
dbNode = backupHost:backupDir
Map to an Alternate Database
Restore an alternate database, by adding mapping information in the following form:
[Mapping]
targetNode: sourceDBNode_backuphost:sourceDB_backuppath
Your mapping section should resemble this example:
[Mapping]
v_sec_node0001 = pri_bsrv01:/archive/backup
v_sec_node0002 = pri_bsrv02:/archive/backup
v_sec_node0003 = pri_bsrv03:/archive/backup